create table street_text

(text_id INT IDENTITY (1,1) CONSTRAINT StreetText_PK PRIMARY KEY,

st_ref INT CONSTRAINT ST_FK REFERENCES STREET(GID) ON DELETE CASCADE,

MS_ANGLE real,

MS_XSCALE real,

MS_YSCALE real,

shape GEOMETRY)

-- Create spatial index

CREATE SPATIAL INDEX StreetTextSdx

ON Street_text(shape)

WITH ( BOUNDING_BOX = ( 0, 0, 500, 500 ) )